SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364543 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364543 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819698,677644,164560,313854,329754,936133,102953,913904,455419,610290,302807,779897,509766,555614,670488,88342,113738,588744,809023,175666,709112,1029652,807298,966084,105281,839786,91901,253958,339726,714241,77891,331711,611723,497754,573209,978017,100869,680788,727047,531391,504444,894012,761943,45785,897628,103056,342665,253855,1016302,1048835,895933,560877,556244,639227,805102,642042,827720,325266,269664,879524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]