SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416658 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416658 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432061,955187,404995,583649,770398,1034265,890127,787927,389275,397630,930859,517071,380491,153836,880138,48866,647630,722026,869379,927822,195066,628365,88396,501779,444624,387314,388464,872570,75134,343861,346669,174932,402627,136148,188387,511584,361062,629996,166032,590783,306680,86759,16056,1037071,76686,802792,133354,589882,965716,953514,683835,886920,925601,51454,106663,51464,915226,414814,688859,628366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002232s ]