SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105840 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105840 [ RunTime:0.003584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132163,147834,846711,1023978,713817,162220,729676,23776,1018840,237626,543210,110787,289977,122468,815628,115410,434307,392599,64908,438986,972909,648685,800142,204947,391294,718746,64705,154739,831816,551370,424954,556380,501271,722748,554234,505925,404796,338131,225950,283401,146477,135489,89615,608150,416893,222013,700981,399311,806401,951370,266031,304232,526983,743348,222832,151311,797437,299902,364988,592868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]