SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547501 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547501 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547523,798728,465347,920080,778085,9081,144409,660678,431220,1045591,892377,808584,769223,363790,825502,969096,944156,140493,224315,1031877,442613,345990,920588,80964,495937,148625,552307,1043571,576668,650421,677156,305649,281191,207055,116411,380022,560575,729611,380859,52053,1022526,526277,254419,915405,57291,833519,20566,892976,76177,905180,306337,333950,772171,688904,850345,536169,613747,801847,196868,971231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]