SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019637 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019637 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154187,1029890,476589,399134,818166,803445,1035765,709949,439810,395668,962283,988046,856047,66666,703517,676955,426684,224443,689396,675533,1020340,289008,881821,269542,536271,986769,691924,825008,434581,658255,742880,264049,704761,297191,76189,178155,718900,191891,35300,803469,725029,387911,864209,193833,703838,156681,970558,340406,239923,957438,167546,912497,989180,579009,752665,528979,746144,602896,387520,953850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019637 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019637 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]