SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395047 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395047 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533425,443439,802072,34464,708552,376583,576423,25715,684136,454638,488423,24439,985852,30929,301351,944659,718584,365026,474009,319397,273842,984988,391935,581358,674368,433247,53286,252147,912405,303379,569390,52491,616424,100942,738358,549402,779693,582496,665208,807377,750750,783661,19334,716783,648258,184455,664519,84803,818241,293174,896896,120372,780950,812709,930840,214898,618407,284825,63091,979585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]