SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113151 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113151 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419836,945573,460168,212766,596984,298108,289576,286824,732546,186534,39168,6653,652892,619565,459357,180598,65637,945473,38440,863477,959093,452216,211171,635387,734323,320139,124965,174093,375884,531810,313231,327464,449501,954842,257494,737697,386124,704222,667729,239162,731817,819880,199681,673655,890590,440854,1006422,173079,49599,408577,922910,106087,131021,950967,613783,348882,447297,854921,162999,956221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]