SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41354 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41354 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672881,321729,116449,398454,820507,630307,871793,50976,879905,737718,155563,542135,13921,228270,85008,590818,51435,356060,81540,170892,492124,271568,529372,1018997,61852,998075,801752,64256,228615,508673,626746,496383,268788,377058,169555,174895,336262,915822,101170,799656,431839,169365,399319,224312,303819,97798,254478,545526,750010,339821,271090,358436,249700,827640,49860,830026,956178,1018487,263442,195192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]