SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505701 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505701 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635171,714879,18446,749870,559575,171243,745811,504381,776687,177028,997137,771135,701016,456240,698033,229200,794958,795756,992869,864384,23732,168484,772607,668908,304320,299189,629749,400570,502979,996770,67063,271770,441171,495850,993396,765831,706326,222444,554135,507977,31143,1017476,248543,801978,519662,888501,683609,309388,867724,988476,398127,793306,391218,555811,893392,369116,617864,151666,591375,314172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]