SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191880 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191880 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407242,682902,496629,416492,142644,395904,624504,328385,103660,815435,282743,339346,874029,1021169,841389,33832,315987,503020,620363,830257,326306,244161,742838,741013,181011,988183,911125,686170,65648,879284,975886,557515,873323,1021770,173844,710157,39226,594102,1004140,861554,848619,535159,355601,214311,881706,948800,494824,81024,413897,212365,934934,644082,845845,922188,471128,650770,149207,245112,4668,547332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]