SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856860 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856860 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783528,980329,999241,27269,770652,59035,333527,349089,677723,443211,1033265,1002985,485952,421941,809383,654903,282952,500884,356586,142358,112500,106250,940827,451979,290513,620246,772149,504414,480709,391092,1027799,473379,900706,75225,779119,993548,563109,905285,518876,4566,599804,514818,26531,843060,1001967,377463,771080,885013,759304,520679,553240,1018098,450093,331203,399195,1596,364570,734879,1038103,60236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]