SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269116 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269116 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153755,672516,9133,584785,10871,393515,872926,518997,529001,1038103,514336,337354,33241,510658,843000,933564,723471,164419,134645,897282,770913,808991,1001206,517338,506203,31447,52562,925685,159678,352889,452682,540330,158211,1010202,113917,1027865,247317,791178,411594,750976,801072,120187,990959,643252,221603,392961,630300,437635,688354,914552,928178,363381,365031,310525,651379,779388,730863,712768,684736,318587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]