SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472724 LIMIT 1 [ RunTime:0.001641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472724 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287819,739505,185894,315568,782002,640800,1024565,110404,840393,596464,55175,408861,776352,1010673,17100,442012,452182,429352,733210,780311,509676,400628,689954,208451,237304,534306,145016,753099,230565,1017778,492900,10295,1048369,282168,570149,433235,420221,997671,444158,298658,630932,164604,931511,15278,834668,491672,780536,304646,344097,246199,611377,704190,537677,300727,561514,576347,184311,370990,623371,193023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000868s ]