SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532535 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532535 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329723,396294,38265,672099,292431,1040776,516293,20818,147689,588861,780469,177717,800610,492578,25884,944159,134366,133659,197159,1003927,908031,32068,75456,1013264,664685,214278,830564,522270,452324,597676,639123,176309,9274,730220,930232,956533,972466,460235,519686,978826,616496,259622,594053,463460,23191,87882,885780,981334,548485,261823,1002657,285005,467203,331752,305251,334234,625549,474441,427948,782942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]