SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109100 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109100 [ RunTime:0.003857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664784,224080,955574,429173,153674,512611,144191,605714,1024837,28681,83494,754078,36028,899108,360818,290658,48640,259271,251233,961288,610920,1008842,641872,750135,818105,62196,733736,168699,196890,808613,360249,941524,633518,786630,310254,161793,642117,392372,348010,302511,167012,281089,39457,568688,561177,949493,377817,537687,908916,780092,590564,777100,335519,943885,674592,970113,445300,903104,1000639,220326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]