SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43760 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43760 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536380,801619,910643,43658,394715,219460,207811,355464,966282,157340,835636,675924,326027,264314,459059,192324,598398,333908,597683,945844,241982,360398,945038,988599,28694,924909,157795,18263,534791,594632,887166,368771,441643,150699,142649,85566,239749,615503,438177,873883,721296,276761,856732,688464,680217,761441,1040419,63698,184064,100789,572265,748522,1008274,464658,195194,238688,989368,422013,196799,110907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001047s ]