SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192796 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192796 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473972,185211,575086,435793,519098,801511,863769,931674,300151,1000151,1010293,691135,1037487,85457,713501,372532,753808,605805,385320,713279,924317,1043938,305558,493962,1044360,836780,352802,91219,798968,761060,609428,439549,96256,555312,793558,459086,988502,343003,882235,551684,675986,83823,294778,275000,934714,1015468,87771,809142,36082,963335,14975,383867,899816,251980,1013049,755044,149746,873104,233474,798164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]