SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012646 LIMIT 1 [ RunTime:0.000743s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012646 [ RunTime:0.004050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575153,473714,64789,74480,675469,135966,983909,393356,524871,102464,630443,143279,23104,932379,612991,741848,533674,660890,989976,389943,288959,869731,995544,470500,147631,588254,45463,520327,869821,735519,711829,78288,996720,865873,1029504,272855,92164,434686,646452,12730,151397,772680,116604,509919,411629,244139,931566,170760,806311,900395,1000799,114804,787915,126631,617830,168015,379141,543040,286250,756455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002480s ]