SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 857281 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 857281 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290201,59494,1031875,998633,1032838,700108,890969,755736,825501,1003083,338310,1015152,489209,418949,848844,904248,391798,505363,467190,712367,902073,968513,961772,807955,491260,113737,433852,680480,939302,205131,517245,767487,45449,1042404,157186,812249,684433,813811,602608,18238,946520,337357,931921,885160,773602,196294,879537,912066,764896,989375,997190,148562,41700,842303,1039825,706208,222012,849333,91417,468298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 857281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 857281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]