SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334028 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334028 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642337,83905,405087,155056,1006567,902421,355171,452903,238825,227346,339442,842532,16229,555441,106892,167762,392142,937554,817551,849407,412922,198212,751854,815333,839986,228911,778277,34363,952110,395446,644198,466658,872841,222087,776968,80243,969848,618399,1046984,964264,809722,868631,800651,297101,999808,368346,790250,274940,385986,561407,804533,753907,777914,651924,586068,209843,613122,147049,230245,220701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]