SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511843 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511843 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182116,65844,1035724,459861,484874,969733,207891,203183,637452,196931,720265,245919,473993,779994,220037,289746,614934,317590,142057,233593,263506,270802,559551,287989,1019405,739211,708294,53884,425444,105871,42232,939129,365309,584688,1038551,672732,508544,653098,450949,170089,284167,35262,897612,883083,491784,91717,896245,668494,562514,295126,62609,418269,659572,909601,797172,12562,67413,887367,744888,53867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]