SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809658 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809658 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002448,230398,950055,170338,879136,514438,1043655,260471,166042,519689,934047,226500,87198,619808,333959,1003180,968417,47,435353,961889,523573,598870,980834,96697,549384,666505,132834,286371,214010,51292,829640,811047,540131,579165,693833,377332,165363,536672,820233,486046,822127,393938,33589,714259,738114,621300,701912,861899,879380,737931,895395,383488,670641,672008,326385,271322,135975,707847,37383,708393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]