SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472413 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472413 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264845,829917,589358,136528,925633,218094,118963,220036,493188,200107,845977,804609,649793,849916,360195,886145,741101,690334,1034860,281593,878554,138407,989167,334533,888653,697455,983568,998370,771121,103536,690839,97993,769177,737723,662309,93188,863736,388362,359655,743553,112515,468547,650949,937965,665887,581381,485826,633463,8745,604840,619320,1042399,800533,803301,959127,358532,219560,842589,122539,979963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]