SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000271 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000271 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170756,212466,195485,443431,354301,160169,617794,925522,351208,59552,810524,99897,206829,1018968,852152,666236,923613,826014,790441,1039391,319154,1041200,772306,921235,884540,831608,765139,739485,1033583,1000975,249399,55183,831848,46040,221531,450531,386506,672772,40680,586041,743037,349595,88567,938171,924456,22690,43171,894648,200356,250453,994269,716468,687600,633571,949857,758129,323151,914697,929181,278370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]