SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022861 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022861 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683015,419888,172655,60843,511510,893320,775967,367881,244508,454143,353098,311633,764526,94479,185600,653543,421299,885288,606616,273921,119760,661718,1012349,549930,846397,421922,335564,698994,675236,357394,447538,841997,784027,590444,475922,260557,847553,1007639,126169,751115,1002145,419365,589098,159004,615269,1013359,187113,268642,231232,623225,62549,426654,881331,209471,248412,370798,8253,194284,856757,259315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005308s ]