SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520249 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520249 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624036,58852,600565,685721,639912,405707,271109,200896,874460,200919,470975,847399,700370,507229,589802,35023,436200,539095,139798,573432,1034732,750549,648357,648876,271555,50903,576376,617712,550509,844471,453557,784395,895737,518838,37595,199154,515713,424546,398401,624515,590546,790946,565399,170285,1017262,45863,766042,200024,637260,645337,209604,995795,724400,136078,6240,386897,162173,992671,698614,127708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]