SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420800 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420800 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849241,236565,444428,141741,494474,472547,420315,415317,455779,367168,596168,642058,648190,462377,560689,544045,691911,166789,330717,832594,669951,26113,995253,674501,205944,234365,679112,628359,163796,88082,1044527,679529,985641,14800,509071,738383,709555,914172,845191,509822,500227,7524,81198,523840,53040,907476,1017789,450627,184742,591665,50426,511698,767192,481851,487632,798298,777903,570697,412861,115621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]