SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043800 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043800 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773026,784207,546693,376744,248095,829270,514918,477459,652438,761063,28956,250533,902714,456542,1041482,464881,846324,416246,880128,51515,332919,876558,231441,1012913,1048118,93599,400762,760520,244174,897035,717776,129291,215830,148013,206346,567733,152595,319252,471165,765437,600714,268826,391104,480244,18213,608184,318452,283894,61501,543402,253900,265406,372941,391975,331871,165443,18551,73552,851228,685948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001726s ]