SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421360 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421360 [ RunTime:0.004519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15808,95018,139976,1028641,150699,865553,1020023,163708,414203,787054,519803,746244,611281,440545,107577,766842,707238,1045568,22175,930202,661106,194098,480816,689423,73151,894117,433374,528064,784382,867874,885874,879781,601745,697565,442876,800749,792450,348300,983656,304407,711235,787826,89800,601589,836137,467220,35702,856069,769312,684761,658238,821773,846655,651664,82046,1037525,24360,111831,509476,656435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421360 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421360 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]