SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440085 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440085 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118998,38955,406265,977686,406499,903707,1032407,831398,407829,1024306,172434,156318,408424,97479,24145,187242,868779,912628,768700,438423,529180,1039414,449041,320716,592045,217682,421214,109829,286708,715562,1043341,27004,384178,931483,818056,979085,658978,415281,432441,190507,979012,692918,413657,265853,392518,313133,102601,210337,560500,117114,284818,972545,266308,499063,741389,863942,913368,451054,676075,455915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001750s ]