SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023987 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023987 [ RunTime:0.002991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802197,297957,852134,996022,519965,925093,818477,697369,212443,25253,13620,856696,717280,809884,166344,365811,739656,967715,331634,40072,238737,757722,329146,210041,648716,851443,762228,344867,500542,475594,812183,2468,1023903,54395,315679,224635,275986,154096,942722,752877,454294,282851,730192,517470,206776,369987,836886,616856,1043747,28411,303553,279615,694758,737087,486940,974148,800637,371189,113644,188015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]