SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028683 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028683 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636842,460780,269856,696092,455426,357513,544501,7099,478329,109793,973547,522763,480146,27012,988097,597217,349800,592145,1030188,718124,970840,772012,606102,187293,237154,19976,60479,396455,133298,509703,816766,345719,319654,294609,676090,387654,396626,972726,887498,387715,173573,562708,344706,743032,747884,394591,299765,7165,336578,556301,716447,458371,441955,100350,511922,854356,579694,647317,447326,165956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]