SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002563s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027943 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027943 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96966,123742,768719,256406,100909,363021,343147,5048,856378,930242,799602,617695,474368,1004750,409341,392210,561177,965396,19151,956159,646028,393492,765068,630420,788342,876724,78492,48819,10643,395537,1007441,374187,262526,837225,698239,789703,246305,715122,499505,737127,546591,948175,868308,526900,556635,461583,224474,893816,4092,304699,671233,716147,854468,16623,808766,260197,928604,570844,126371,350297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]