SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020892 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020892 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229843,115884,788754,243516,432778,719898,726441,874751,429178,29323,262082,973090,684418,270657,623547,303282,213185,31884,734442,664036,797512,868281,738927,34578,167009,788919,587975,604178,755264,214732,10250,319912,836835,308881,171806,446114,1006395,235892,116074,486045,658619,648552,424976,440047,384367,312699,649459,3935,357380,907417,631125,857390,717525,219170,863407,846158,57271,75424,375614,876258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]