SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533016 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533016 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259790,901017,202571,485763,864700,613046,426022,895150,391350,740000,956016,920494,242700,476438,177371,1015315,708622,7343,88560,513432,169106,855000,303197,479640,401972,434259,268957,790553,384661,679418,245230,140479,381663,374255,894329,700518,145691,721751,494425,180292,795664,704015,270651,289528,952043,999436,121690,508437,628198,973975,303487,1039816,782314,1041710,403395,1028125,809979,842529,774067,491524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]