SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801980 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801980 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118769,530487,520880,2258,606292,645729,870371,525033,766916,97402,495321,922191,388854,804126,167585,107346,76085,680863,933751,548966,60836,846345,106837,49455,1009944,990325,907427,749724,379514,281798,625217,244743,366050,183406,959901,376781,1010374,504842,646462,660133,552543,632983,284913,215301,389828,2772,366885,697807,71202,421112,181492,897735,631788,710214,526579,859155,235801,491229,428155,143762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]