SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981005 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981005 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509158,979898,959030,574040,1021090,360011,88495,196235,865247,1048598,66076,860959,549295,304200,840540,671318,336953,279597,766414,485923,339838,132453,912870,743865,137004,391543,549592,39566,626463,256154,939327,815592,663012,444661,134265,678972,993284,588451,324234,848945,728772,7607,456405,270214,707175,825038,204262,255378,367144,230966,943003,10906,729354,991246,99178,175069,713716,450210,232442,716025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981005 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981005 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001435s ]