SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530310 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530310 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649088,544146,700724,20434,336501,760962,720661,677553,832490,749700,787110,548456,125196,344499,441614,305990,471396,439281,19926,550115,373427,681287,17743,522590,535253,131097,237624,452315,349137,307724,353154,683522,976216,994926,807375,382345,535203,446949,935825,114981,635621,7773,331849,956846,1045811,939207,1007988,498698,690890,747841,421855,965987,98221,635526,1006146,987980,29265,143058,200642,1036259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]