SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102922 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102922 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265917,513033,848899,997923,340771,953447,242327,460889,993592,674508,125388,681760,410074,708426,307323,224815,764273,97998,949856,948654,910850,1013996,829590,301379,714078,141548,70523,502581,235956,819324,695642,459770,179134,730943,926014,25225,450942,181649,602451,10975,920066,934097,736665,961702,224424,860570,719634,304117,965821,359932,710190,786905,360872,187727,424148,956826,310161,349952,1027698,186668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]