SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403205 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403205 [ RunTime:0.002569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719339,771572,260296,106811,894224,217678,1047868,1012876,483608,21071,196086,209891,723756,173521,717997,634633,537408,857203,656665,6681,610165,771073,564021,270340,736895,868545,374227,308507,651678,709427,18268,1020981,657339,748836,825696,148202,561841,812730,70908,542370,825088,255166,1003659,88104,855995,721494,158683,570354,370266,467849,73002,1021398,789691,845408,748282,141149,594044,133776,524943,1031169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]