SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462071 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462071 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52288,858833,85887,991502,415121,110084,385621,745770,70431,976295,81880,624012,562610,34152,505068,27208,612598,49233,800090,775528,723344,788554,735375,903952,750517,421351,860205,568711,1044619,594073,869054,925094,954073,346535,93209,1048687,860615,721576,439540,20870,179024,775490,854731,40107,675140,313690,192486,628754,382011,225712,555224,419293,568326,401998,817036,804930,464453,1900,745738,35595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]