SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445634 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445634 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45556,342,107326,1008556,956877,225040,111097,636402,844596,6911,253507,149123,822951,139296,681430,81000,383054,915614,164166,109941,561563,255276,326628,501092,584356,275570,692234,382121,969579,377322,678926,194551,982917,929607,2562,75940,804149,515546,556477,1033898,255251,922521,360937,833107,508382,616294,935162,453712,941845,1012252,166890,900451,282229,918171,203116,927203,347747,932357,330598,640525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]