SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47301 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47301 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039334,193153,494420,1034063,290388,628851,456075,1024924,429634,785643,368795,666099,147181,459027,850734,205415,10406,62531,1025887,377441,85080,616447,224878,927233,668069,807380,820414,782311,107238,591484,917719,768282,839946,490239,475392,1046914,200814,432990,897233,562494,346950,682512,461172,389561,212663,291817,351551,127640,956955,682599,825565,608506,464025,951166,917086,864830,664150,357283,168147,188985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]