SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501726 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501726 [ RunTime:0.001274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871091,948817,519046,972905,603596,6000,60207,959030,108855,103174,339820,819679,742826,865112,437913,874257,619686,504057,858410,385295,218921,999321,283396,1019048,145400,440075,988224,292292,745584,597860,602221,698158,8771,345085,378670,703312,562276,294200,48339,381227,681454,835641,729241,280720,668041,1043161,691798,832054,386912,959871,838709,508628,710902,445873,309080,200720,125707,587406,548128,39105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]