SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556711 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556711 [ RunTime:0.003364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872279,446137,1043016,90445,436463,683396,333486,16004,774536,362795,617525,120260,440724,722061,595462,968733,400022,936719,991310,687735,682346,935986,1033296,537045,181517,89853,590273,490398,18762,581758,914841,239127,914339,821676,232199,834009,289604,410996,117200,420561,536448,872484,142376,869742,258540,721181,536034,354905,158014,958856,893693,466615,374632,601898,614141,179956,1043668,925383,302257,50404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]