SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546806 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546806 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24216,80529,569325,42939,1010905,170060,946545,947282,424547,104673,920838,565930,887000,497996,991870,541165,873065,129819,368460,721570,766928,317350,335209,601762,784342,74296,175010,131446,729498,389076,717898,960425,1030865,526074,862269,142682,411305,859092,423075,452514,808551,308562,827477,996205,965156,841788,606479,839051,175956,195048,593411,71455,247377,12995,354189,279240,265865,497598,640332,266777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]