SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287249 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287249 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715219,73952,992763,397642,965560,393454,955189,104191,205369,671509,916225,568803,181781,126275,540419,247646,435388,359550,203957,921051,332628,872175,606480,27562,756016,550331,574309,11811,427271,866494,323782,27833,791744,95567,665350,479579,474439,74636,1018866,105868,53706,621698,509743,12090,539836,291479,373786,26561,158465,451355,607583,691407,268914,469411,711719,465413,311629,299577,712123,316176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001296s ]