SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319685 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319685 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487067,437841,59539,1007928,441403,343839,219920,884560,603409,708579,23289,180133,758811,1043948,210734,793299,446799,136716,674463,572939,663639,401397,85941,75874,597503,130915,401574,441683,1046699,191542,538190,991320,391956,1045679,397014,417938,409017,682263,888808,59162,583900,507669,22369,217456,593802,519230,338006,628149,969575,591012,117001,879775,957375,300902,176782,992558,995321,125404,130459,763547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]