SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539511 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539511 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578187,578706,1034563,624828,423404,504065,347507,427144,690795,757391,754595,884162,155272,227112,933125,699306,224389,727993,392732,16393,256853,522584,242610,240370,757190,926654,1045442,206482,816116,356613,344651,805098,114683,874027,572701,438595,453349,453125,93919,551625,935485,488557,214730,702458,807961,1017954,942717,361125,961814,601874,657801,313952,657950,105375,620517,63221,936504,1012472,1020424,433447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]