SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580911 LIMIT 1 [ RunTime:0.001511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580911 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607677,267186,68573,977132,151495,519098,756660,259919,967469,458514,528066,980964,527234,985746,477336,270743,180063,400475,491721,214935,38070,370587,276490,233875,149656,722476,382043,231790,326860,703158,76658,269601,454824,565438,325724,13080,347155,944836,752108,984175,331137,178473,865576,157832,686414,273784,543000,271597,560515,767603,241293,266177,367440,39843,749525,702244,983093,359338,603261,262678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]