SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38300 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38300 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495588,409403,360350,367952,56775,652869,44461,889693,663663,503051,509604,627720,604403,309176,898831,622254,31160,626435,423422,265827,439002,892270,42270,379015,960960,210964,360284,765749,750591,843446,100378,640094,368266,805887,992835,201903,353796,796250,23397,453406,540931,450226,881032,960388,1025885,1027800,796053,225962,495733,356730,212950,765082,837319,887521,451364,879817,15882,399432,866672,647688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]