SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507097 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507097 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459903,725714,907677,699012,602391,1012754,822865,565987,268709,449795,33609,656196,83671,35204,547838,364455,38397,686299,617176,588642,543918,859585,295386,273092,383605,280702,102216,310854,442723,504160,776350,1027570,1009330,714740,811629,255631,917362,566355,410251,644257,81283,845927,350654,55239,684166,1014274,167658,997603,597600,562233,1021787,302819,135744,989926,1043040,146726,600224,725221,562846,248693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004143s ]