SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029822 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029822 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722912,426768,190155,485703,649490,227934,627296,294679,728110,170532,131688,703903,222726,26265,384684,390272,66052,523551,905290,422253,308741,78780,222094,318095,483452,346230,502060,72003,223416,887614,846960,694930,566437,138257,874394,216847,886148,410299,1014681,693436,233026,702283,793119,802924,885247,729176,211286,636326,987635,824659,1014135,598781,1010659,270840,309915,694635,167659,96585,709645,497118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001292s ]