SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027911 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027911 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130825,334874,245108,998447,93904,345926,219949,748340,1045687,274802,153825,151983,118051,878010,596884,895089,41920,124362,836080,1022597,1010433,571425,843857,958821,985253,398036,124462,655606,178983,248303,491146,571115,964298,639899,793255,963043,706872,236276,123415,256807,873922,715990,993146,612030,50618,457810,836409,15704,486345,781829,19499,519205,908295,798597,596414,107095,583387,152414,46512,943745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]