SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403806 LIMIT 1 [ RunTime:0.001682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403806 [ RunTime:0.003725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671248,853395,719919,580008,639266,1048547,209186,335533,948191,116442,308160,773972,241915,897900,604886,665519,622573,601182,405352,1002366,253831,592004,19137,361138,800361,923264,1041584,850219,939711,523527,291152,120763,1033552,1040688,715092,196605,150265,778593,486983,586762,936235,527812,388509,860855,893646,324389,806358,346881,287722,98575,314704,636943,926892,135835,954346,406768,29514,1011007,298062,516738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]