SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571046 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571046 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320295,226009,678869,1034069,1012599,212766,19669,698631,1004244,580383,964028,528236,148607,653923,147423,711702,106877,633712,934873,934396,641112,369026,154293,384830,370626,194082,1012854,851784,759128,1015250,303616,653268,12319,813550,908818,1007705,782675,922455,562460,926344,101684,13342,636352,438167,686143,471888,34529,156747,129636,312063,893904,802268,148217,491802,568726,309381,1017987,367716,862639,882371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]