SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040329 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040329 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553112,423132,361039,37157,350077,443320,528166,478015,23769,769919,227928,304276,1008446,342511,487573,622017,665244,326212,512398,452066,544937,995739,653463,933324,958654,446771,1009174,132610,399453,133232,830526,203337,525143,721649,947026,1043187,892657,795325,970532,355321,619716,543695,151193,670311,561566,588177,964228,635894,214135,963616,110276,870997,93973,343850,267215,623606,527678,198271,589040,383440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]