SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004959 LIMIT 1 [ RunTime:0.000797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004959 [ RunTime:0.004405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592003,472966,277137,964696,651825,333295,391562,670353,402505,238880,1018511,796523,927356,872838,102311,917621,774230,702545,459946,646732,418750,20937,805459,965092,148274,345424,291648,740936,672203,610737,105071,651244,383738,316581,994881,766613,827316,354821,607686,172062,369037,502125,824330,200725,46058,945049,700442,609016,929830,223920,462417,305516,201640,791936,698843,721515,195413,510715,221874,813798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]