SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10160 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10160 [ RunTime:0.003688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644183,679752,630199,804553,117805,992864,255755,538679,546331,714113,936786,445352,84220,31896,3625,950056,259767,232250,214142,789308,862319,1559,482810,311524,288427,129261,287713,265840,68420,775157,678582,483032,138710,718050,611944,585088,355125,664210,724916,655281,138131,973977,503506,902781,872473,925248,180279,275716,776352,619690,848808,374944,191908,327745,461442,176631,709367,256856,931298,674003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]