SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803580 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803580 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701999,448528,194252,816093,854686,995038,863354,772683,486171,838396,729423,805755,148090,113293,635175,730035,395384,324047,104841,299162,855129,1025137,267833,128340,790146,824848,229680,121699,615886,176314,68182,270730,188579,40906,968994,217454,111591,207160,71189,394132,979257,494581,665900,537431,696490,628641,715154,632448,1041322,35508,90934,746892,430666,578154,250194,431030,2691,259836,246912,702261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001462s ]