SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027049 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027049 [ RunTime:0.002744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196696,869026,246377,553481,369852,573577,339360,515721,375044,282286,1006711,7749,341318,676110,591173,190464,971523,798013,1007925,175803,259769,395950,1028975,590759,1006926,993071,395976,307792,814147,779263,794927,668538,175398,531284,875280,1041884,780735,250383,349620,330558,42441,663913,620794,322787,95714,339080,489196,149943,571191,369679,75976,18735,958694,784899,10369,69948,751231,148889,839500,973432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]