SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318093 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318093 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158180,452133,254802,262666,533207,69320,399434,822806,457427,372237,619879,427808,880607,410948,677946,88392,715,82553,425693,833233,597273,442623,1021232,814287,924095,979093,577375,114253,618053,136073,114193,89709,716126,291224,1688,16175,461122,495199,457441,364691,769989,637587,494301,857193,366632,724262,4170,3402,506602,954667,35764,887507,946746,182922,232646,818662,678640,1034643,810919,765234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]