SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035946 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035946 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533574,379548,694097,440227,978450,405520,24276,432558,852439,627067,586839,161652,932899,592668,903273,130986,477523,706590,649502,194543,609265,627209,289833,338609,894820,861103,1048906,400,731998,176235,15249,292982,633365,345690,264684,362307,297662,875215,75688,1045744,998965,833378,284955,646091,991952,15804,648695,13067,940784,704241,420442,675248,877762,149442,409,462031,1042932,212663,675759,898485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]