SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644027 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644027 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517368,177669,160643,139794,1009871,119044,1023868,850704,684464,565151,144582,639366,506927,706320,210439,789298,1048072,662782,725220,765164,649985,1036847,54869,380645,732071,833905,195964,552033,608590,732544,887660,754766,670707,156533,690755,153359,416798,100328,387272,928121,827917,346233,852021,565329,241049,470313,10453,70612,426878,646301,1017600,74627,378675,463652,901798,538007,586461,767358,990767,848327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]