SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481941 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481941 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920916,687796,85536,178034,675919,1003107,218559,182929,1011341,1017530,146491,282028,270377,839624,968184,369115,460318,755267,275523,816041,19238,808022,634513,912973,230116,77211,323552,816700,82627,562063,464699,364173,304510,609864,535842,5134,866733,734406,838118,934144,407531,441580,421233,450721,960482,532137,135782,267538,876988,858104,650778,67347,11112,1014380,720299,1035697,694563,9474,24293,736496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]