SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543823 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543823 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45304,749828,1011603,432537,716251,806378,448988,347793,401507,48671,745470,623494,517277,383990,132533,403719,79206,921888,1018869,16357,291550,468849,285278,814503,824178,216665,691424,664856,982322,713437,1019419,60848,738750,772137,826468,692065,309994,810712,396593,591366,921551,341695,556227,230073,723497,733739,973139,335311,501633,760916,823229,239050,492916,229445,785239,837552,399590,1012151,497295,271721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]