SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407508 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407508 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409757,728554,406408,136139,72088,993755,466571,442055,169333,481486,900656,198198,369377,923158,444732,652534,1042352,340121,934439,95753,571659,216707,271877,198449,145453,802149,633891,730245,848496,100758,539442,372939,431025,76470,339460,960141,143878,503480,714761,698097,413370,241685,120070,224073,334249,732360,405838,93425,227088,856534,881156,653049,63566,26744,75603,659199,911008,445090,277405,837721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]