SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804240 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804240 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832195,364949,167330,963190,358294,352759,447260,265480,226060,975165,869359,62303,7782,1015919,295438,53123,511677,346726,307603,989416,421443,928221,757049,385700,343854,33948,254016,292896,156925,323001,30268,475100,88685,772489,973130,139513,302539,766082,552361,437624,1043555,687155,345401,693209,461554,983575,898852,771772,409877,335507,955597,179728,326602,562462,673309,559135,740894,327235,856043,1008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]