SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547502 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547502 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938400,768419,237042,256772,670615,435591,699071,806845,470277,87870,918882,74483,296130,883791,89588,134996,792335,642653,959371,528461,808116,281357,169696,410558,351165,932392,20098,60383,135219,126161,1046803,484468,943831,918568,986433,11902,286476,138169,1041282,843578,914870,926834,807785,448584,635939,502973,360291,397748,152367,480389,482337,66399,419015,448047,986477,323862,374367,237689,60624,116620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]