SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802516 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802516 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536427,782200,551269,951865,285249,614897,220775,231592,112910,432345,810546,738388,96616,740605,154424,528052,546655,889935,102097,649201,912524,627239,468288,445536,954443,1036298,402431,777368,238754,1030931,1025868,745511,719194,50543,873430,977993,14458,703012,719887,840855,662029,653129,702497,145402,389764,206337,621982,725767,423223,141507,738843,694529,298118,87700,637492,595196,747762,361274,705289,167682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]