SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465197 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465197 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129873,810393,713031,860967,1300,415183,762201,416602,850225,726573,1011299,320209,689513,905379,865844,394386,971656,510355,658758,521307,694863,929922,524385,326366,78568,125521,730254,246714,179943,276374,385492,470735,722864,352225,177840,148497,920763,1011663,240990,485073,311797,1021842,271311,128720,314513,629930,491980,269759,502248,448408,625238,84492,505102,663643,298706,933028,448605,424651,632878,501619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]