SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553958 LIMIT 1 [ RunTime:0.001003s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553958 [ RunTime:0.005673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037054,42525,642133,2044,143072,704911,795368,36218,76253,298336,674892,170621,453291,354209,812014,484972,566253,178747,595798,903383,66313,441198,195155,1039546,599716,1029428,103092,1007633,353544,59869,239197,549096,606670,366139,724568,776828,951550,507488,337832,749457,377427,314367,281700,677812,492,319093,556598,726995,161532,258508,907019,768731,384047,463843,194212,604644,128052,305678,510097,993141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]