SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451599 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451599 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196922,392541,751772,143890,1020727,765503,350321,765948,795210,558973,313063,507844,809787,165464,996527,895429,324071,773153,901784,724607,116884,313739,793722,513621,490382,35079,781556,284320,199977,238616,110066,481081,21648,351689,848714,852035,248340,988030,441182,560260,889328,92487,572137,635776,608859,619884,420445,380049,149915,219272,988000,878983,707768,860546,984567,981030,1006232,134849,650879,783176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]