SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512410 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512410 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891219,468542,60961,903568,678275,665335,455933,734717,175313,364558,276207,882427,460243,100480,818332,269249,325575,103802,465968,964511,274098,817183,869179,801735,711581,890366,439428,724688,533909,764289,27786,387353,883861,940276,34735,760808,535000,471765,961979,759619,1012058,498023,153528,429891,267678,1040953,675157,191348,979704,129087,837772,700355,504283,592898,901351,141735,108607,682091,789288,869258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]