SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803440 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803440 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229148,832560,168004,242126,253702,26073,21383,575718,609255,284091,904813,274356,47556,870252,811260,677265,166871,996163,228825,353658,559202,223392,403031,898801,29189,305072,937267,901972,929426,335474,877112,675441,940551,426205,461616,954678,767870,984951,938892,856811,507309,604988,669197,533214,596357,393421,530654,810550,141442,800460,1039222,798681,468574,789511,224103,95345,508514,212466,591414,798641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001428s ]