SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431945 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431945 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438765,713845,897821,250026,597503,964434,474190,521409,181584,906996,187162,656816,165069,937283,210678,248775,386801,479756,323477,686154,412128,473954,245901,725633,708123,334404,514744,475401,1026585,732104,340450,88973,759426,164598,377231,258116,925320,908176,671112,967836,838983,882408,50195,620923,311727,787867,406020,705205,143255,205766,311300,700920,985436,696749,402712,805465,509612,588445,410606,118776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]