SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510336 LIMIT 1 [ RunTime:0.002188s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510336 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743680,714743,37500,23434,949689,389857,212848,426795,378061,393807,874502,523618,1010107,672969,565587,529705,980132,386706,322048,294107,315833,584719,727556,684989,534985,902400,750562,62906,980922,508761,321402,400977,803436,347173,470055,306277,799758,438139,1013021,1036753,400729,827250,12927,246155,390247,964461,523455,456032,849911,134372,174866,199992,552026,375313,644377,379262,57745,698677,976809,412802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002970s ]