SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508531 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508531 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152689,416637,415958,720292,691870,936221,907759,348656,657118,753114,260734,763468,834154,101180,716557,724111,448509,193510,633763,116357,340403,539212,168796,473850,468098,694142,166924,248058,513016,240109,817178,116454,369429,174714,709696,722220,689540,794681,59378,972892,789157,730441,594166,815743,810184,485586,849698,741238,70213,405111,428573,1024621,1041548,609915,119110,514630,354710,507369,777112,882733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]