SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313151 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313151 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85437,93604,82110,677324,822895,50630,161487,873347,730891,14412,780642,385985,982609,855354,8574,120283,438243,480896,919500,69753,235200,556006,887406,991510,273738,624078,403671,854090,335242,127251,792578,169806,738441,727030,479130,988676,757245,216820,826074,234184,178521,694187,874476,713127,448085,617185,746054,706602,426999,999310,907828,752190,100246,22099,523097,132649,245454,622030,739556,411468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]