SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014923 LIMIT 1 [ RunTime:0.002026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014923 [ RunTime:0.003473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437497,625364,698664,937784,21876,64271,282044,320625,813288,213853,296665,268576,726265,926454,20754,537407,889935,783151,258149,763913,926644,190228,13354,928366,465858,731002,187644,357043,31517,524914,780398,407756,128063,607876,356351,301330,203118,1035775,580383,333694,785148,228530,315810,392551,415885,311253,504483,32649,123570,430360,734350,248547,83737,316073,440668,961363,33262,513269,517352,802935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002596s ]