SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803931 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803931 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969924,536276,1029680,347859,1017799,675687,578215,925366,1023582,788679,550894,673850,688084,117552,292064,956488,365482,252514,16919,26597,837061,492476,855101,190424,928459,667902,768944,632837,1035534,662869,206471,716440,756888,182083,274847,183491,63600,458139,1045645,37264,420764,152941,391689,14131,30783,518481,51891,400665,288778,828683,881097,110367,1025540,197428,490629,735403,378777,170353,760511,1026603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000899s ]