SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496478 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496478 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444026,749,205316,590707,1020396,47593,808677,520409,1670,137944,458721,634967,129335,6392,424279,315076,700499,637294,428474,1041988,173681,984433,623873,302755,880977,261445,439735,592271,655417,239126,749880,318715,204472,767176,454678,880378,576898,441072,299145,1033222,1032344,153411,448288,310653,304001,199528,764462,514408,356715,802224,270654,890542,852462,882872,114262,431155,250751,793752,140461,957755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]