SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44097 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44097 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111796,774482,248697,865907,216115,581324,681042,131283,681217,607874,708633,721991,748373,943149,603935,29678,662493,672758,611905,70100,824884,226591,952974,307213,45627,530019,914361,403736,91681,301971,324463,153602,27242,1005289,730401,672015,354806,788800,127367,336150,665499,17704,152023,903860,473273,390652,761763,96360,831458,821079,1017007,934233,673296,991561,308582,616505,315454,164664,721346,48368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]