SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444591 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444591 [ RunTime:0.004518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048160,66126,886283,798533,37388,754116,59853,999456,671914,967340,554460,734661,1022407,326512,807187,20431,665859,372023,812024,708927,1018668,112419,117698,162219,268941,212963,608598,313215,857571,734859,471478,444472,215372,129852,383699,392248,443859,695365,589761,226715,355965,964706,320340,528114,55438,414631,240352,219505,453746,30982,11121,45778,330828,176375,865073,708052,286141,946279,563844,320942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002002s ]