SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446971 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446971 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240150,801619,390377,34384,864441,840457,300441,671220,20125,360197,762339,156499,233088,782156,654082,47503,771348,432589,46729,688742,437026,639557,98343,134246,545182,62557,393328,370610,613171,716652,590678,23765,663573,618299,191764,920166,326607,366052,335552,562596,122425,402013,129309,912589,255040,762604,640969,544433,967471,384935,743182,498158,716063,419703,438276,706359,141365,979267,560104,698612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]