SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671084 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671084 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848018,931669,57877,81913,812801,25985,1003390,865571,108312,686760,392578,134062,751632,914557,1014284,76772,199745,1016343,863038,179329,439067,1039231,349486,892067,753556,204641,429267,486888,720483,944637,809272,669570,628589,1042723,463859,976661,480599,905960,44442,906065,388628,380783,424364,80170,123458,743850,545910,597821,126002,1014711,193201,828951,29129,727445,51276,153847,606459,674732,722156,613077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001264s ]