SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039110 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039110 [ RunTime:0.003484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838754,846965,571562,733769,935280,1031938,860029,98256,85632,1032389,873567,976207,375730,176380,485664,464073,148846,37828,624500,816070,826680,526514,386559,29468,714623,445387,877843,965419,133354,84232,932960,7636,937631,568377,1043405,8076,978767,289696,590906,798432,876741,837404,390778,333820,382761,48791,648850,520423,646127,222693,506769,155849,205281,294975,516135,405408,548689,843756,1037139,804339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]